{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Serviceability Calculator","Administration","HEM","Branding","Postcodes","Calculations","HEM Calculator","Drivers","Scope Inputs","Scope Results","Scope General"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":137,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Serviceability Calculator","index":0,"n_rows":406,"n_cols":11,"rows_kept":406,"cut":false,"hidden":false,"merged":[[255,1,255,5],[280,1,280,5],[286,1,286,5],[296,1,296,5],[306,1,306,5],[272,1,272,5],[288,1,289,1],[153,1,153,5],[178,1,178,5],[184,1,184,5],[204,1,204,5],[194,1,194,5],[323,1,323,5],[405,1,405,5],[354,1,354,5],[376,1,376,5],[327,1,327,5],[337,1,337,5],[329,1,330,1],[325,2,325,4],[237,1,238,1],[229,1,229,5],[235,1,235,5],[245,1,245,5],[4,1,4,5],[33,1,34,1],[84,1,85,1],[135,1,136,1],[186,1,187,1],[17,1,17,5],[68,1,68,5],[119,1,119,5],[170,1,170,5],[221,1,221,5],[25,1,25,5],[31,1,31,5],[411,1,411,5],[406,1,406,5],[407,1,407,5],[408,1,408,5],[409,1,409,5],[410,1,410,5],[102,1,102,5],[127,1,127,5],[133,1,133,5],[143,1,143,5],[41,1,41,5],[51,1,51,5],[76,1,76,5],[82,1,82,5],[92,1,92,5]]}
[null,null,null,null,null,{"$f":"\"Version: \"&vVersion","v":"Version: 1.00 (11 Dec 2023)"}]
[null,null,null,null,null,null,null,"Print Option included"]
[]
[]
[null,"Loan Details",null,null,null,null,null,"26 April Notes","2nd May","10th May"]
[]
[null,"Loan Amount",213213,"Security Value",1000000,null,null,"Validate Loan Amount can not be more than Security \"Loan Amount can not be more than the Security Value\""]
[]
[null,"Term (months)",360,"Actual Rate (%)",5.1900000000000002E-2]
[]
[null,"Repayment Type","Principal and Interest","I/O Period (years)",0,null,null,null,"P&I default to zero for I/O (display as N/A)"]
[]
[null,"Regulated Loan","Yes","Purpose of Loan","Purchase",null,null,"\"Residential Loan\" changed to \"Type of Loan\" with \"RMDS or CMDS\" options"," \"Loan Type\" Removed with \"Regulated Loan\" now driving \"Buffer\" selection, & \"Purpose of Loan\" included - \"Purchase\" / \"Refinance\" / \"Other\""]
[]
[null,"Number of Individuals",1,"Company Income Used",null,null,null,null,"These moved to End and leading into Applicant/Company Details"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A18)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 1"},null,null,null,null,null,null,null,"Applicant default to colapsed"]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A18)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant",null,null,null,null,"Joint with Applicant Default to zero if not Couple (display as N/A)"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross",150000]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)",null,null,null,null,null,null,"Rental Income Double Click Issue repaired"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A69)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 2"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A69)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A120)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 3"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A120)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A171)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 4"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A171)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A222)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 5"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A222)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A273)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 6"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A273)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[null,"Company Details",null,null,null,null,null,null,null,"Company default to colapsed"]
[]
[null,"Company Name"]
[]
[null,"Income  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[null,"Commitments (Monthly)"]
[]
[null,"Number of Commitments",null,null,null,null,null,"If Zero then Commitments cleared"]
[]
[null,null,"Commitment","Repayment Amount","Commitment Limit",null,null,"If repayment blank then use Benchmark 30 years 5.25%"]
[null,"Commitment 1"]
[null,"Commitment 2"]
[null,"Commitment 3"]
[null,"Commitment 4"]
[null,"Commitment 5"]
[null,"Commitment 6"]
[null,"Commitment 7"]
[null,"Commitment 8"]
[null,"Commitment 9"]
[null,"Commitment 10"]
[]
[null,"Total Credit Card Limits"]
[]
[null,"Declared Living Costs",null,"Benchmark Living Costs",{"$f":"vHEM_Amount","v":0},null,null,"Benchmark Living Costs included",null,"HEM Bug, Poscode Calcs"]
[]
[]
[]
[null,"Serviceability Calculation",null,null,null,null,null,null,null,null,"Calculation Notes"]
[]
[null,"Actual","Annual","Assessment","Annual"]
[]
[null,"Gross Income",{"$f":"Calculations!C33+Calculations!C66+Calculations!C35","v":150000},"Gross Income",{"$f":"C381","v":150000},null,null,null,null,null,"Taxable Income and Non-Taxable Income for Applicants and Company"]
[]
[null,"Taxable Income",{"$f":"Calculations!C33+Calculations!C66","v":150000},"Taxable Income",{"$f":"C383","v":150000},null,null,null,null,null,"Taxable Gross Annual Income for Applicants and Company"]
[]
[null,"Net Income",{"$f":"Calculations!C37+Calculations!C69","v":106433},"Net Income",{"$f":"C385","v":106433},null,null,null,null,null,"Net Annual Income for Applicants and Company"]
[]
[null,"Total Commitments",{"$f":"Calculations!D84","v":0},"Other Commitments",{"$f":"Calculations!C84","v":0},null,null,null,null,null,"Total Commitments Calculated"]
[]
[null,"Living Costs",{"$f":"Calculations!D85","v":0},"Living Costs",{"$f":"Calculations!C85","v":0},null,null,null,null,null,"Actual Living Costs and HEM"]
[]
[null,"Net Available Income",{"$f":"IF(C385-C387-C389<0,0,C385-C387-C389)","v":106433},"Net Available Income",{"$f":"IF(E385-E387-E389<0,0,E385-E387-E389)","v":106433},null,null,null,null,null,"Net Income - Commitments - Living Costs"]
[]
[null,"Proposed Repayments",{"$f":"IF(ISERROR(vRepayments),0,vRepayments)","v":14033.508121406219},"Proposed Repayments",{"$f":"IF(ISERROR(vAssessed_Repayments),0,vAssessed_Repayments)","v":19113.762301329465},null,null,null,null,null,"Assessment takes I/O period into account"]
[]
[null,"Net Disposable Income",{"$f":"IF(C391-C393<0,0,C391-C393)","v":92399.491878593777},"Net Disposable Income",{"$f":"IF(E391-E393<0,0,E391-E393)","v":87319.237698670535},null,null,null,null,null,"Net Available Income - Proposed Repayments"]
[]
[null,null,null,{"$f":"IF(vResidential,\"NDI\",\"NDI\")&\" Ratio\"","v":"NDI Ratio"},{"$f":"IF(vResidential,vAssessed_NDI,vAssessed_NDI)","v":"5.57 : 1"},null,null,null,null,"NDI always, no DSC","NDI = (Assessment Net Income - Living Costs) / (Assessment Commitments + Proposed Repayments)"]
[null,null,null,null,null,null,null,null,null,null,"DCS = Net Income Assessment / (Commitments Assessment + Proposed Repayments)"]
[null,null,null,"DTI Ratio",{"$f":"vAssessed_DTI","v":"1.4"},null,null,null,null,null,"Total Loan Limits / ( Total Income Actual + Income Addbacks )"]
[]
[null,null,null,"LVR",{"$f":"vLVR","v":0.2132},null,null,null,null,null,"Application Loan Amount / Application Details Security Value"]
[]
[null,null,null,"Maximum Loan Amount",{"$f":"-PV((vLoan_Rate+vBuffer)/12,(vLoan_Term-IF(bIO,vLoan_IOPeriod,0)*12),vAssessed_Available_Income/12)","v":1187254.4437481929},null,null,null,null,null,"Excel PV Formula using : Interest = (Loan Actual Rate + Buffer entered), Application Loan Term in Years with I/O adjustment if applicable, Net Available Income Assessment"]
[]
[]
[null,"Notes  (Optional)",null,null,null,null,null,"Notes Included"]

{"sheet":"Administration","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,1,1,4],[3,2,3,3]]}
[]
[null,"Administration"]
[]
[null,"Version","1.00 (11 Dec 2023)"]
[]
[null,"Parameter","Regulated","Unregulated"]
[null,"Buffer",0.03,0.03]
[null,"Buffer (for Refinance)",0.03,0.03,null,null,"Purpose of Loan Refinance Buffer included"]
[null,"Floor Rate",0.06,0.06]
[null,"Interest Gearing",3.7499999999999999E-2,3.7499999999999999E-2]
[null,"Credit Card Rate",3.7999999999999999E-2,3.7999999999999999E-2]
[null,"Loan Term (years)",30,30]
[null,"Rental Shading",0.8,0.8]
[null,"Property Expense %",0,0,null,null,"Property Expense % included"]
[]
[null,"PAYG","Taxable Income from","% on Excess","Income Tax"]
[null,null,0,0,0]
[null,null,18200,0.19,{"$f":"(C18-C17)*D17+E17","v":0}]
[null,null,45000,0.32500000000000001,{"$f":"(C19-C18)*D18+E18","v":5092}]
[null,null,120000,0.37,29467]
[null,null,180000,0.45,51667]
[]
[null,"Medicare",0.02]
[]
[null,"Company Tax Rate",0.25]

{"sheet":"HEM","index":2,"n_rows":170,"n_cols":18,"rows_kept":170,"cut":false,"hidden":true,"merged":[[0,4,0,17],[0,0,0,2]]}
["Categories",null,null,"HEM","Gross Income (from)"]
["Region","Household","Dependents",null,0,24000,36000,48000,59000,71000,95000,119000,143000,166000,190000,238000,297000,357000]
[]
[]
[null,null,null,"Australia"]
["Australia","Couple",0,"Couple",0,532.42973384371567,547.51941906492004,567.05290633065761,602.69592692681624,656.01041965608351,733.01513219276899,799.16985722062418,886.7218959544673,924.11453048820385,977.11351891557911,1082.8643933617741,1193.9326116365705,1251.3499709853943]
["Australia","Couple",1,"Couple with 1 child",0,0,630.8434875320396,650.42382151863706,686.15236478677889,739.59483166203495,816.78429426848982,883.09778762597909,970.85994136652039,1008.342306207358,1061.4684751762206,1167.473117739014,1278.807864046918,1336.3630066076378]
["Australia","Couple",2,"Couple with 2 children",0,0,695.31829652238127,714.88371606260012,750.5850704587267,803.98686391838862,881.11756683413751,947.38056148763496,1035.0759254181264,1072.5297389573395,1125.6154661722164,1231.5394137826154,1342.789407651042,1400.3007004790463]
["Australia","Couple","3 and above","Couple with 3 children",0,0,0,776.36998186169342,812.07061459768408,865.47136032090373,942.60067554730051,1008.8624153789758,1096.5561186230327,1134.0091499654882,1187.093963064078,1293.0159047934928,1404.2637919216377,1461.773959191642]
[null,""]
["Australia","Single",0,"Single person",272.51336479239524,287.22192057292256,302.33916563665485,321.9082870717744,357.61636310064671,411.0281742488645,488.17343533646613,554.4488964628373,642.16077114032487,679.62161801725483,732.71733988831295,838.66126668664845,949.9322424984399,1007.454326726418]
["Australia","Single",1,"Single parent with 1 child",0,379.86779023505159,394.95467916735311,414.48447812536591,450.12080933233534,503.42531884913882,580.41563540425602,646.55796157633597,734.09362752685888,771.47916285205145,824.46825450046094,930.19932709911575,1041.2467287380782,1098.6533268063242]
["Australia","Single",2,"Single parent with 2 children",0,495.37900719699513,510.62176819550018,530.35343203295929,566.35804215060011,620.21342000973357,697.99935513696585,764.82522035492696,853.26549357844169,891.03740311968397,944.57414024409684,1051.3978397295507,1163.5928827036455,1221.5926680459936]
["Australia","Single","3 and above","Single parent with 3 children",0,0,635.44638296274047,655.59792856069703,692.36863356370191,747.36992938701917,826.81094125600953,895.05870643028857,985.38076547475964,1023.9563927283655,1078.6323054387019,1187.7289287860578,1302.3112605168267,1361.5450721153843]
[]
[]
[null,null,null,"Sydney"]
["Sydney","Couple",0,"Couple",0,518.60306705539699,533.69278868479478,553.22623954233893,588.86926013849757,642.18378927595813,719.18850181264361,785.34324504459551,872.89526557434203,910.28790010807847,963.28688853545373,1069.0377629816487,1180.1059812564454,1237.5233406052689]
["Sydney","Couple",1,"Couple with 1 child",0,0,615.1903222925265,634.77065627912395,670.49919954726579,723.94164817474109,801.13114727675736,867.44462238646588,955.20677612700729,992.68914096784499,1045.8153099367078,1151.8199524995009,1263.1546988074049,1320.7098048725632]
["Sydney","Couple",2,"Couple with 2 children",0,0,680.66526921750688,700.23069787467045,735.93204315385219,789.33383661351411,866.46453952926299,932.72753418276045,1020.4228981132519,1057.876711652465,1110.9624571012318,1216.8864047116308,1328.1363985800569,1385.6476549402821]
["Sydney","Couple","3 and above","Couple with 3 children",0,0,0,765.59105796007225,801.29176363024078,854.69250935346042,931.82175164567934,998.08349147735476,1085.7771947214117,1123.2302989980446,1176.3150209289124,1282.2369626583272,1393.4848862535612,1450.9950535235653]
[null,""]
["Sydney","Single",0,"Single person",258.01615678538991,272.72469432859458,287.84193483299617,307.41106082744642,343.11913229698803,396.53094344520582,473.67620453280745,539.95168389650121,627.6635403366663,665.12438721359615,718.22014555929968,824.16403588298965,935.43502993210393,992.95711416008203]
["Sydney","Single",1,"Single parent with 1 child",0,365.13456791034946,380.22143864196607,399.75126945117739,435.38760065814688,488.69211927529273,565.68239942904029,631.82472560112035,719.36039155164326,756.74596327820529,809.7350185252451,915.4660911238999,1026.5135291642323,1083.9200544297387]
["Sydney","Single",2,"Single parent with 2 children",0,479.04665597143543,494.28946294188393,514.0210808073997,550.02569092504029,603.88106878417398,681.66699471701747,748.49285993497847,836.93315154727065,874.70507947729038,928.2417982129258,1035.065516087157,1147.2605222836971,1205.2603076260452]
["Sydney","Single","3 and above","Single parent with 3 children",0,0,617.28897329477161,637.44039212740381,674.21109713040858,729.21238356370202,808.65341421274047,876.90117938701917,967.22327599158643,1005.7989032451924,1060.4748159555288,1169.5714768629807,1284.1536959134614,1343.3875826322114]
[]
[]
[null,null,null,"Balance of NSW"]
["Balance of NSW","Couple",0,"Couple",0,547.6036494203338,562.69336194768334,582.22682190727596,617.86983340138624,671.18433523270164,748.18904776938712,814.34377279724242,901.89588434747236,939.28842786072539,992.28741628810064,1098.0383089383924,1209.1066000295757,1266.5238865620124]
["Balance of NSW","Couple",1,"Couple with 1 child",0,0,644.26046024050697,663.84078510321433,699.56932837135594,753.01180437050232,830.20126697695719,896.51474208666593,984.27691407498787,1021.7592606680449,1074.8854478846881,1180.8900904474815,1292.2248367553857,1349.779979316105]
["Balance of NSW","Couple",2,"Couple with 2 children",0,0,709.71326870268467,729.27873382762778,764.98005175597484,818.38184521563676,895.51254813138576,961.7755427848831,1049.470888481485,1086.9247202545878,1140.0104292355752,1245.9343768459742,1357.1844071821799,1414.6957364779637]
["Balance of NSW","Couple","3 and above","Couple with 3 children",0,0,0,794.63850736350651,830.3392221504472,883.73996787366684,960.86921016588576,1027.1310229317389,1114.8247079422513,1152.2777392847067,1205.3624794491188,1311.2844211785336,1422.5323812408565,1480.0425849779494]
[null,""]
["Balance of NSW","Single",0,"Single person",287.06964804697958,301.77818103085349,316.89542609458579,336.46455208903603,372.17261899924699,425.58444838478744,502.72970947238906,569.00517971742158,656.71705439490916,694.17788303451641,747.27362314289735,853.21749522926461,964.48850751570149,1022.0105917436797]
["Balance of NSW","Single",1,"Single parent with 1 child",0,394.12968762496257,409.21658110743533,428.74637096510571,464.38271127241757,517.68722078922099,594.67749184262618,660.81985441607583,748.35548396522904,785.74107389247615,838.73016554088554,944.46120173817064,1055.508639778503,1112.9151650440097]
["Balance of NSW","Single",2,"Single parent with 2 children",0,508.34140349376833,523.58421046421677,543.31582832973254,579.3204476417618,633.17586227845015,710.96178821129377,777.78765342925476,866.22794504154706,903.99987297156667,957.53653654086997,1064.3602728038786,1176.5552790004188,1234.5551378978764]
["Balance of NSW","Single","3 and above","Single parent with 3 children",0,0,647.20700307992797,667.35846416766822,704.12917856069703,759.13054950420667,838.57158954326928,906.81931715745191,997.14145132211536,1035.7170597956731,1090.392822265625,1199.4895582932695,1314.07177734375,1373.3058143028843]
[]
[]
[null,null,null,"Melbourne"]
["Melbourne","Couple",0,"Couple",0,539.71634224063246,554.806054767982,574.33951472757462,609.98252622168491,663.2970280530003,740.30174058968578,806.45650202573449,894.00854075957761,931.40115708921735,984.40016372068942,1090.1510199627876,1201.2192746457777,1258.6365611782146]
["Melbourne","Couple",1,"Couple with 1 child",0,0,636.3542260580881,655.93458741635664,691.66313980838879,745.10557018808345,822.29506929009972,888.60854439980824,976.3707163881304,1013.8530082378453,1066.9792501978307,1172.9838745128434,1284.3186573163086,1341.8737268859056]
["Melbourne","Couple",2,"Couple with 2 children",0,0,701.81306217730003,721.37851818529873,757.07986346448047,810.48159310552819,887.61236895683612,953.87536361033347,1041.5707275408251,1079.024468144479,1132.1102682949154,1238.0342159053141,1349.2842097737405,1406.7955026017451]
["Melbourne","Couple","3 and above","Couple with 3 children",0,0,0,786.73847779458936,822.43911964735241,875.83993830474981,952.96918059696873,1019.230920428644,1106.924623672701,1144.377727949334,1197.4624681137464,1303.3844098431612,1414.632296971306,1472.1424642413103]
[null,""]
["Melbourne","Single",0,"Single person",279.16794500034723,293.87648254355184,308.9937412852762,328.56284904240368,364.27091595261464,417.68274533815514,494.82800642575677,561.10347667078929,648.81535134827686,686.27617998788412,739.37192009626506,845.31581041995503,956.5868227063919,1014.10890693437]
["Melbourne","Single",1,"Single parent with 1 child",0,386.24386325090302,401.33075218320454,420.86055114121734,456.49688234818683,509.80139186499019,586.79170842010751,652.93404369252983,740.469691442368,777.8552449682453,830.8443366166548,936.57542741599445,1047.622829054957,1105.0293907218334]
["Melbourne","Single",2,"Single parent with 2 children",0,500.37411630011098,515.6168864930047,535.34854113607526,571.35316044810452,625.2085383072382,702.9944642400817,769.82032945804269,858.26062107033488,896.03251222279971,949.56924934721258,1056.3929672214438,1168.5880101955388,1226.5877955378869]
["Melbourne","Single","3 and above","Single parent with 3 children",0,0,639.07015286959131,659.2216796875,695.99240347055286,750.99369929387035,830.43469238281261,898.68244816706738,989.00456355168262,1027.5801344651441,1082.2560471754807,1191.3526893028845,1305.9350210336538,1365.1688701923076]
[]
[]
[null,null,null,"Balance of VIC"]
["Balance of VIC","Couple",0,"Couple",0,576.46760093751675,591.55732256691465,611.09077342445869,646.73379402061744,700.04829585193295,777.05300838861842,843.20773341647362,930.75980855851014,968.15242488814999,1021.1514133155252,1126.9022877617201,1237.9705060365168,1295.3878289771469]
["Balance of VIC","Couple",1,"Couple with 1 child",0,0,673.19367596616542,692.77404644832427,728.50258971646599,781.94499272448968,859.13452832206724,925.44800343177587,1013.2101754200978,1050.692449022032,1103.8186909820174,1209.8233335448108,1321.1581163482763,1378.713185917873]
["Balance of VIC","Couple",2,"Couple with 2 children",0,0,738.62450489785397,758.18992443807281,793.89123324947479,847.29299024135742,924.42376609266535,990.6867789800524,1078.382124676654,1115.8358835141978,1168.9216836646342,1274.8456312750329,1386.0956251434593,1443.6068815036845]
["Balance of VIC","Couple","3 and above","Couple with 3 children",0,0,0,823.54919606681756,859.24981968603606,912.65065657697789,989.77988063565238,1056.0416387008722,1143.7353237113846,1181.1884462215621,1234.2731499188856,1340.1950916483004,1451.4430152435341,1508.9531825135384]
[null,"",null,null,null,null,{"$f":"G56*52","v":38408.474254688408},{"$f":"ROUND(G56,0)*52","v":38428}]
["Balance of VIC","Single",0,"Single person",315.98628643897501,330.69482398217963,345.81208272390393,365.38119048103152,401.08928018789578,454.50109133611363,531.64635242371514,597.92182266874761,685.63369734623541,723.09452598584255,776.19024785690078,882.13413818059075,993.40516870435033,1050.9272529323284]
["Balance of VIC","Single",1,"Single parent with 1 child",0,422.98823850082829,438.07513198330099,457.60492184097137,493.2412530479408,546.54576256474422,623.5360791198616,689.67840529194143,777.21407124246446,814.59960656765691,867.58871641675114,973.31973441335151,1084.3672088550534,1141.77373412056]
["Balance of VIC","Single",2,"Single parent with 2 children",0,537.49822599124127,552.74098698974615,572.47265082720537,608.47726094484619,662.33263880397965,740.11857393121193,806.94443914917292,895.38473076146522,933.15662191392994,986.69335903834292,1093.5170769125739,1205.712083109114,1263.711905229017]
["Balance of VIC","Single","3 and above","Single parent with 3 children",0,0,676.98415902944703,697.13571401742786,733.90641902043285,788.90771484375,868.34872671274036,936.59649188701917,1026.9185884915867,1065.4941781850962,1120.1700721153848,1229.2667893629805,1343.8489708533652,1403.0829326923076]
[]
[]
[null,null,null,"Brisbane"]
["Brisbane","Couple",0,"Couple",0,510.93731283453786,526.02699805574241,545.56048532147986,581.20349681559026,634.51800774895401,711.52272028563959,777.6774453134949,865.22952045553131,902.62206396878435,955.62112521254642,1061.3719814546448,1172.4402361376347,1229.8575226700714]
["Brisbane","Couple",1,"Couple with 1 child",0,0,607.50613622929575,627.08646109200288,662.81501348403503,716.25745298762001,793.44695208963628,859.76046369490621,947.52263568322826,985.00490928516251,1038.1310782540254,1144.1357390645994,1255.470558363626,1313.0256279332227]
["Brisbane","Couple",2,"Couple with 2 children",0,0,672.98693266250109,692.55235220272004,728.25369748190155,781.65545447378406,858.78623032509199,925.04922497858922,1012.7445889090808,1050.198329512735,1103.2840567276121,1209.2080043380111,1320.4581076097757,1377.9693639700008]
["Brisbane","Couple","3 and above","Couple with 3 children",0,0,0,757.91285769289482,793.61352689597459,847.01427261919412,924.1435878455909,990.4053276772662,1078.099030921323,1115.552080497323,1168.6368024281908,1274.5588170917831,1385.8067042199282,1443.3168714899323]
[null,""]
["Brisbane","Single",0,"Single person",250.33637232045373,265.04490758399305,280.16216632571741,299.73127408284489,335.4393501117172,388.851161259935,465.99642234753657,532.2719290672145,619.98376727005677,657.44459590966392,710.54035425536756,816.48424457905764,927.75518391620358,985.27730461882709]
["Brisbane","Single",1,"Single parent with 1 child",0,357.47020946950499,372.55709840180651,392.08691556050417,427.72324676747365,481.02775628427707,558.01803643802452,624.16036261010458,711.6960285606275,749.08160028718976,802.07065553422945,907.8017099321994,1018.849220775271,1076.2557460407777]
["Brisbane","Single",2,"Single parent with 2 children",0,471.3030958379685,486.54589361402833,506.27752067393277,542.28213079157342,596.13750865070699,673.92342538916182,740.74934577345505,829.18958221941523,866.96152853821218,920.49819210751548,1027.3218915929692,1139.5170081221738,1197.5167934645219]
["Brisbane","Single","3 and above","Single parent with 3 children",0,0,609.380615234375,629.53206693209131,666.30277193509608,721.30406775841357,800.74507962740392,868.99295748197119,959.31494140625011,997.89060621995191,1052.56640625,1161.6630483774038,1276.2454176682695,1335.4793043870195]
[]
[]
[null,null,null,"Balance of QLD"]
["Balance of QLD","Couple",0,"Couple",0,553.23119105664034,568.32086717579648,587.85436354358239,623.49737503769279,676.81187686900819,753.81658940569366,819.97131443354886,907.5233895755855,944.91593308883841,997.9149943326006,1103.6658869828923,1214.7341052576887,1272.1513917901257]
["Balance of QLD","Couple",1,"Couple with 1 child",0,0,649.90150616838184,669.48183103108897,705.21037429923081,758.65281380281579,835.84234940039335,902.15582451010198,989.91799649842392,1027.4002701003583,1080.5264573170016,1186.531099879795,1297.8659191788217,1355.4209887484187]
["Balance of QLD","Couple",2,"Couple with 2 children",0,0,715.35002044191265,734.91544909907634,770.61679437825796,824.01856048708532,901.14933633839325,967.41233099189049,1055.1076766884923,1092.5614355260361,1145.6471809748032,1251.5711650529815,1362.8211953891873,1420.3324517494125]
["Balance of QLD","Couple","3 and above","Couple with 3 children",0,0,0,800.27518882669892,835.97583067946186,889.37657640268151,966.50589162907829,1032.7676314607536,1120.4613347048105,1157.9143660472657,1210.9991609123113,1316.9211026417261,1428.1689897698711,1485.6791935069641]
[null,""]
["Balance of QLD","Single",0,"Single person",292.70744052237671,307.41598034524662,322.53323908697098,342.10234684409852,377.81041375430942,431.22222490252727,508.3674859901289,574.64299270980678,662.35486738729446,699.81565955225631,752.91143613528254,858.85530822164981,970.12628403344127,1027.6483682614194]
["Balance of QLD","Single",1,"Single parent with 1 child",0,399.75617908591482,414.84306801821629,434.37285787588672,470.00919818319858,523.31370770000206,600.30398785374962,666.44630492548708,753.98197087601011,791.36756080325711,844.35661605029691,950.0876522475819,1061.1351630906536,1118.5416883561602]
["Balance of QLD","Single",2,"Single parent with 2 children",0,514.02603658290786,529.26884355335631,549.00046141887219,585.00508073090157,638.86045859003502,716.64638452287863,783.47228651839441,871.91257813068671,909.68446928315154,963.22113285245473,1070.0448691154634,1182.2399488671131,1240.2397342094614]
["Balance of QLD","Single","3 and above","Single parent with 3 children",0,0,653.01259202223548,673.16405310997607,709.93476750300488,764.93606332632203,844.37709397536048,912.62494365985572,1002.9470402644231,1041.5225736177886,1096.1983736478364,1205.2951096754807,1319.8774038461538,1379.1112905649038]
[]
[]
[null,null,null,"Adelaide"]
["Adelaide","Couple",0,"Couple",0,552.12205185312826,567.21177348252616,586.74522434007042,622.38824493622906,675.7027376654961,752.7074502021818,818.862175230037,906.41428678026682,943.80684849761667,996.80583692499192,1102.5567113711868,1213.62500246237,1271.042288994807]
["Adelaide","Couple",1,"Couple with 1 child",0,0,648.78970538719307,668.37003937379075,704.09858264193235,757.54106776496906,834.73053037142392,901.04400548113267,988.80615922167385,1026.2885240625117,1079.4146930313743,1185.4193355941677,1296.7540819020717,1354.3092609583525]
["Adelaide","Couple",2,"Couple with 2 children",0,0,714.23907512466781,733.80453113266606,769.50584906101301,822.90764252067504,900.03834543642404,966.30134008992127,1053.9967040204128,1091.450517559626,1144.536263008393,1250.4602106187917,1361.7102044872181,1419.2215337830021]
["Adelaide","Couple","3 and above","Couple with 3 children",0,0,0,799.16421896355587,834.86493375049668,888.2656794737162,965.39492176593512,1031.6567345317885,1119.3504377758452,1156.803487351845,1209.8881910491684,1315.8101327785832,1427.0581293079947,1484.5682965779988]
[null,""]
["Adelaide","Single",0,"Single person",291.59628376347388,306.30483954400125,321.42208004840285,340.99120604285309,376.6992775123947,430.1111068979352,507.25636798553683,573.5318473492307,661.24370378939568,698.70451419168012,751.80027253738376,857.74416286107373,969.0151569101879,1026.5372411381661]
["Adelaide","Single",1,"Single parent with 1 child",0,398.64725230974403,413.73414579221674,433.26393564988717,468.90026685685655,522.20477637366002,599.19506562775007,665.33742820119971,752.87305775035293,790.25862947691508,843.24772112532446,948.97875732260957,1060.026195362942,1117.4327206284486]
["Adelaide","Single",2,"Single parent with 2 children",0,512.90565434810333,528.1484521241631,547.88007918406754,583.88468930170825,637.7401039383966,715.5260298712401,782.35189508920109,870.79218670149339,908.56411463151301,962.10079658959376,1068.9245144638248,1181.119520660365,1239.1193795578229]
["Adelaide","Single","3 and above","Single parent with 3 children",0,0,651.86835186298072,672.01983173076917,708.79053673377416,763.79190767728369,843.23292893629809,911.48065655048072,1001.8027907151442,1040.37841796875,1095.0542179987983,1204.1509164663462,1318.7331355168269,1377.9671724759617]
[]
[]
[null,null,null,"Balance of SA"]
["Balance of SA","Couple",0,"Couple",0,512.59041775348032,527.68013028082987,547.21359024042226,582.85660173453255,636.17110356584817,713.17581610253364,779.33057753858225,866.88261627242537,904.2752326020651,957.27423923353717,1063.0250954756355,1174.0933501586253,1231.5106366910622]
["Balance of SA","Couple",1,"Couple with 1 child",0,0,609.16320806883357,628.74356942710199,664.47212181913414,717.9145521988288,795.10405130084496,861.41752641055371,949.17969839887564,986.66199024859066,1039.7882322085761,1145.7928565235886,1257.1276393270541,1314.6827088966509]
["Balance of SA","Couple",2,"Couple with 2 children",0,0,674.64274307301116,694.20819908100952,729.909553477136,783.31131046901839,860.4420498525468,926.70504450604426,1014.4004084365357,1051.8541490401897,1104.9399491906258,1210.8638968010248,1322.1138906694512,1379.6251834974557]
["Balance of SA","Couple","3 and above","Couple with 3 children",0,0,0,759.56867321442473,795.26931506718768,848.67013372458507,925.79937601680399,992.0611158484794,1079.7548190925363,1117.2078504349915,1170.2926635335816,1276.2146052629964,1387.4624923911413,1444.9726596611456]
[null,""]
["Balance of SA","Single",0,"Single person",251.99251043448243,266.70104797768704,281.8183067194114,301.38741447653888,337.09548138674984,390.5073107722904,467.65257185989196,533.92804210492443,621.63991678241212,659.10074542201937,712.1964855304002,818.14037585409028,929.41138814052704,986.93347236850525]
["Balance of SA","Single",1,"Single parent with 1 child",0,359.12304096146448,374.20991169308115,393.73971065109401,429.37604185806339,482.68055137486687,559.67086792998407,625.8132032024065,713.34885095224456,750.73440447812197,803.72349612653136,909.45455052450131,1020.5019885648336,1077.9085502317098]
["Balance of SA","Single",2,"Single parent with 2 children",0,472.97299910209136,488.21576929498497,507.94743313244425,543.9520432500849,597.80742110921847,675.59334704206208,742.41921226002296,830.85950387231526,868.63143180233487,922.16813214919296,1028.9918500234241,1141.186892997519,1199.1866783398673]
["Balance of SA","Single","3 and above","Single parent with 3 children",0,0,611.08600323016822,631.237548828125,668.00825383112976,723.00954965444726,802.45054274338952,870.69829852764417,961.02041391225953,999.59605994591345,1054.2718975360576,1163.3685772235576,1277.9508713942307,1337.1847205528845]
[]
[]
[null,null,null,"Perth"]
["Perth","Couple",0,"Couple",0,473.6840579671566,488.77377959655445,508.30723045409866,543.95025105025729,597.2647528815728,674.26945631620993,740.42419954816194,827.97625648610165,865.36885461164479,918.36787944721345,1024.1187538934084,1135.1869721682051,1192.604258700642]
["Perth","Couple",1,"Couple with 1 child",0,0,570.16348552122406,589.74385600338303,625.47236277596346,678.91483877510973,756.10434700101632,822.41782211072496,910.17997585126636,947.66226770098126,1000.7885096609666,1106.79315222376,1218.127898531664,1275.6830045968222]
["Perth","Couple",2,"Couple with 2 children",0,0,635.67270866620663,655.23817379114985,690.93951907033147,744.34127606221386,821.47201544574239,887.73501009923962,975.4303740297313,1012.8841146333854,1065.9699147838214,1171.8938806281101,1283.1438744965362,1340.6551308567614]
["Perth","Couple","3 and above","Couple with 3 children",0,0,0,720.59938589963542,756.30005510271496,809.70076435884573,886.83007958524252,953.09181941691782,1040.7855226609747,1078.23855400343,1131.3233488684755,1237.2452905978903,1348.4932141931242,1406.0033814631283]
[null,""]
["Perth","Single",0,"Single person",213.01514354717341,227.72368109037805,242.84092159477967,262.41004758922992,298.11811905877153,351.52993020698932,428.67520953191359,494.95068889560747,582.66254533577239,620.12339221270236,673.21911408376059,779.16300440745056,890.43399845656472,947.95608268454282]
["Perth","Single",1,"Single parent with 1 child",0,320.22395943527346,335.31084836757498,354.84064277541654,390.47697398238603,443.78149259953193,520.77176365293701,586.91413532672902,674.44976487588235,711.8353366024445,764.824428250854,870.55548264882395,981.60293888984108,1039.0094641553476]
["Perth","Single",2,"Single parent with 2 children",0,433.67190641575047,448.91471338619897,468.64633125171468,504.65094136935528,558.50635600604369,636.2922819388873,703.11814715684829,791.55843876914048,829.33036669916021,882.86704865724073,989.69080330902671,1101.8858095055671,1159.8855948479152]
["Perth","Single","3 and above","Single parent with 3 children",0,0,570.94871638371399,591.10017277644238,627.87087777944703,682.87223933293262,762.31327937199535,830.56099759615392,920.88313176081726,959.45875901442309,1014.1345590444711,1123.2313138521636,1237.8135141225962,1297.0474008413464]
[]
[]
[null,null,null,"Balance of WA"]
["Balance of WA","Couple",0,"Couple",0,524.17095386682956,539.26066639417911,558.79412635377173,594.43713784788201,647.75163967919741,724.756352215883,790.9111136519316,878.46315238577472,915.85576871541457,968.85475714278982,1074.6056315889848,1185.6738862719747,1243.0911728044116]
["Balance of WA","Couple",1,"Couple with 1 child",0,0,620.77153374755596,640.3518951058245,676.08043837396633,729.52287787755131,806.71237697956747,873.0258520892761,960.78802407759815,998.27029767953252,1051.3965578872985,1157.401182202311,1268.7359650057765,1326.2910345753733]
["Balance of WA","Couple",2,"Couple with 2 children",0,0,686.24222291532647,705.80768804026968,741.50904243639616,794.91076296049914,872.04153881180707,938.3045334653043,1025.9998791619062,1063.4536379994499,1116.5394381498861,1222.4633857602851,1333.7133796287112,1391.2246724567158]
["Balance of WA","Couple","3 and above","Couple with 3 children",0,0,0,771.16794251425142,806.86865730119223,860.26940302441187,937.39864531663079,1003.6603851483062,1091.3540883923629,1128.8071926689959,1181.8919328334082,1287.8138380957341,1399.0617616909678,1456.5719289609722]
[null,""]
["Balance of WA","Single",0,"Single person",263.59418327461054,278.30272081781516,293.41997955953951,312.989087316667,348.69715422687796,402.10898361241846,479.25424470002002,545.52971494505255,633.24158962254012,670.70241826214749,723.79815837052831,829.74203045689569,941.01306098065515,998.53514520863348]
["Balance of WA","Single",1,"Single parent with 1 child",0,370.7014066267165,385.78827735833318,405.3180672160035,440.95440752331541,494.25891704011889,571.24922449489361,637.39156886765841,724.92721661749658,762.312770143374,815.30186179178338,921.03291618975334,1032.0803542300855,1089.4868794955921]
["Balance of WA","Single",2,"Single parent with 2 children",0,484.67101984265918,499.91379003555289,519.64544467862345,555.65006399065271,609.50544184978628,687.29136778262989,754.11723300059089,842.55752461288319,880.3294525429028,933.86615288976088,1040.6898707639921,1152.8848769605322,1210.8846990804352]
["Balance of WA","Single","3 and above","Single parent with 3 children",0,0,623.03293081430297,643.18446702223559,679.95518141526441,734.95647723858156,814.39747971754821,882.64522611177892,972.96734149639417,1011.5429875300481,1066.2188251201924,1175.3155048076924,1289.8977238581733,1349.1316856971157]
[]
[]
[null,null,null,"Hobart"]
["Hobart","Couple",0,"Couple",0,563.72153843113858,578.81126006053648,598.34471091808052,633.98772241219092,687.30222424350643,764.3069367801919,830.46171642033721,918.01377335827715,955.40633507562677,1008.4053052989053,1114.1561797451004,1225.2245072444771,1282.641793776914]
["Hobart","Couple",1,"Couple with 1 child",0,0,660.41702700560211,679.99739748776096,715.72594987979301,769.1683893833781,846.35785198983297,912.67140009066429,1000.4334808400829,1037.9158456809205,1091.042032897564,1197.0466389647959,1308.3814947593842,1365.9365643289809]
["Hobart","Couple",2,"Couple with 2 children",0,0,725.85754556314919,745.42300157114755,781.12435596727391,834.52611295915653,911.65681587490542,977.9198834639617,1065.6151744588942,1103.069006231997,1156.1547152129845,1262.0786628233834,1373.3287660951482,1430.8400224553734]
["Hobart","Couple","3 and above","Couple with 3 children",0,0,0,810.78246938315158,846.48318417009239,899.88392989331203,977.0132451197087,1043.2749849513841,1130.9686699618967,1168.4217195378963,1221.5064597023086,1327.4284014317234,1438.6763614940462,1496.1865287640503]
[null,""]
["Hobart","Single",0,"Single person",303.21695989386279,317.92549743706746,333.04275617879176,352.61186849524995,388.31993540546091,441.73176479100147,518.87701675994163,585.15250524229691,672.86436168246178,710.32520855939174,763.42093043044986,869.36482075413994,980.6357965659314,1038.1579172685549]
["Hobart","Single",1,"Single parent with 1 child",0,410.24456488792146,425.33145837039416,444.8612482280646,480.49757943503408,533.80209805217987,610.79237820592743,676.93474077937708,764.47040672990011,801.85594205509244,854.84503370350205,960.57608810147201,1071.6234897404345,1129.0300514073108]
["Hobart","Single",2,"Single parent with 2 children",0,524.62281780594071,539.86562477638915,559.5972794194596,595.60188953710031,649.45726739623387,727.24319332907737,794.06905854703848,882.50935015933067,920.28127808935028,973.81794165865358,1080.6416595328847,1192.8367760620893,1250.8365614044376]
["Hobart","Single","3 and above","Single parent with 3 children",0,0,663.83484825721166,683.98638446514406,720.75708946814905,775.75837590144226,855.19940655048072,923.44713416466357,1013.7692307692307,1052.3448955829326,1107.0206580528845,1216.1173377403845,1330.6998197115386,1389.9336688701924]
[]
[]
[null,null,null,"Balance of TAS"]
["Balance of TAS","Couple",0,"Couple",0,557.98546397032874,573.07517649767829,592.60863645727079,628.25164795138107,681.56614978269658,758.57089872757547,824.72562375543077,912.2776988974673,949.67024241072033,1002.6692308380955,1108.4201781006773,1219.4884327836673,1276.9057193161041]
["Balance of TAS","Couple",1,"Couple with 1 child",0,0,654.66722430488244,674.2475491675898,709.9760924357314,763.41853193931638,840.60806753689405,906.92154264660269,994.68371463492474,1032.165988236859,1085.2921572057217,1191.296799768515,1302.6316555631031,1360.1867251326998]
["Balance of TAS","Couple",2,"Couple with 2 children",0,0,720.11211072411515,739.67753938127885,775.37889377740532,828.78065076928772,905.91142662059565,972.17442127409299,1059.8697669706949,1097.3235258082386,1150.4092530231158,1256.3332006335147,1367.5832674374999,1425.0945602655047]
["Balance of TAS","Couple","3 and above","Couple with 3 children",0,0,0,805.03718892923416,840.73783078199722,894.13857650521675,971.26789173161353,1037.5296315632888,1125.2233348073457,1162.676366149801,1215.7611063142133,1321.683011576539,1432.9310081059507,1490.441175375955]
[null,""]
["Balance of TAS","Single",0,"Single person",297.47041142416714,312.17896720469446,327.29620770909611,346.8653337035463,382.57340061375726,435.98521176197511,513.13047284957668,579.40594309460914,667.11781777209683,704.57864641170409,757.67438652008491,863.61831331842041,974.88925265556645,1032.4113368835444]
["Balance of TAS","Single",1,"Single parent with 1 child",0,404.50956094391302,419.59644987621454,439.12623973388486,474.76258004119677,528.06712595936983,605.05739701277503,671.19974138553982,758.73538913537789,796.120979062625,849.11003430966468,954.84108870763464,1065.8884903465971,1123.2950884148431]
["Balance of TAS","Single",2,"Single parent with 2 children",0,518.82857840913118,534.07134860202484,553.8030032450954,589.80762255712466,643.66300041625834,721.44892634910184,788.27479156706283,876.71508317935513,914.48701110937475,968.02367467867805,1074.847392552909,1187.0424723045589,1245.0422944244619]
["Balance of TAS","Single","3 and above","Single parent with 3 children",0,0,657.91728327824512,678.06881948617786,714.83953387920656,769.84079214242797,849.28183218149036,917.52957857572108,1007.8516939603367,1046.4273024338941,1101.1031024639424,1210.1997821514422,1324.7821890024038,1384.0160757211538]
[]
[]
[null,null,null,"ACT & NT"]
["ACT & NT","Couple",0,"Couple",0,568.94661479563501,584.0363364250328,603.56979638462531,639.2128078787357,692.52730971005121,769.53202224673669,835.68678368278529,923.23885882482182,960.63140233807485,1013.6303907654501,1119.3812652116451,1230.449592711022,1287.8668792434587]
["ACT & NT","Couple",1,"Couple with 1 child",0,0,665.65465099823325,685.2350123565019,720.9635556246435,774.4059951282286,851.59545773468346,917.90900583551479,1005.6711048327141,1043.1534514257712,1096.2796203946339,1202.2842629574272,1313.6191187520151,1371.1741883216118]
["ACT & NT","Couple",2,"Couple with 2 children",0,0,731.09117335102007,750.65663847596329,786.35797463819995,839.75974986397227,916.89045277972116,983.15352036877755,1070.8488660653793,1108.3026066690334,1161.3883521178002,1267.3122997281992,1378.5623665321846,1436.0736593601889]
["ACT & NT","Couple","3 and above","Couple with 3 children",0,0,0,816.01600717862539,851.71672196556619,905.11746768878572,982.24678291518251,1048.508522746858,1136.2022077573704,1173.6552573333702,1226.7399974977823,1332.6619027601082,1443.9098992895197,1501.420066559524]
[null,""]
["ACT & NT","Single",0,"Single person",308.45157303717787,323.16011058038248,338.27736932210684,357.84648163856502,393.55454854877598,446.96637793431643,524.11163902191799,590.38710926695057,678.09898394443826,715.5598125840454,768.65553445510363,874.59944301611631,985.87041882790777,1043.392503055886]
["ACT & NT","Single",1,"Single parent with 1 child",0,415.46866195776835,430.55555544024111,450.08534529791154,485.72168560522334,539.02619512202682,616.0165025768016,682.15882874888155,769.69449469940457,807.08004822528187,860.06913987369137,965.80019427166133,1076.8475959106238,1134.2541211761304]
["ACT & NT","Single",2,"Single parent with 2 children",0,529.90093938757207,545.14370958046561,564.87536422353628,600.87997434117699,654.73536139469923,732.52128732754272,799.34715254550372,887.78744415779602,925.55937208781563,979.09603565711893,1085.9197535313501,1198.1148332829998,1256.1146554029028]
["ACT & NT","Single","3 and above","Single parent with 3 children",0,0,669.22523850661048,689.37677471454322,726.14747032752416,781.14878493088941,860.58978740985572,928.83755258413453,1019.1596491887019,1057.7352952223557,1112.4110576923076,1221.5077373798076,1336.0901442307693,1395.3241060697117]

{"sheet":"Branding","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[[3,2,3,3],[8,2,8,3],[6,2,6,5],[1,2,1,5]]}
[]
[null,null,"Form Logo"]
[]
[]
[]
[]
[null,null,"Form Colors"]
[]
[null,null,"Enter the Hex Code",null,null,"Color"]
[]
[null,null,"Header 1","#1c355e"]
[]
[null,null,"Header 2","#4cc2e1"]
[]
[null,null,"Data Entry","#FFFFFF"]

{"sheet":"Postcodes","index":4,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["From","To","State","Location"]
[200,799,"ACT","Non Metro"]
[800,820,"NT","Metro"]
[821,827,"NT","Non Metro"]
[828,832,"NT","Metro"]
[833,999,"NT","Non Metro"]
[1000,1920,"NSW","Metro"]
[1921,1999,"NSW","Non Metro"]
[2000,2005,"NSW","Inner City"]
[2006,2249,"NSW","Metro"]
[2250,2557,"NSW","Non Metro"]
[2558,2574,"NSW","Metro"]
[2575,2599,"NSW","Non Metro"]
[2600,2639,"ACT","Metro"]
[2640,2739,"NSW","Non Metro"]
[2740,2786,"NSW","Metro"]
[2787,2899,"NSW","Non Metro"]
[2900,2920,"ACT","Metro"]
[2921,2999,"NSW","Non Metro"]
[3000,3010,"VIC","Inner City"]
[3011,3216,"VIC","Metro"]
[3217,3334,"VIC","Non Metro"]
[3335,3341,"VIC","Metro"]
[3342,3424,"VIC","Non Metro"]
[3425,3443,"VIC","Metro"]
[3444,3749,"VIC","Non Metro"]
[3750,3811,"VIC","Metro"]
[3812,3909,"VIC","Non Metro"]
[3910,3920,"VIC","Metro"]
[3921,3925,"VIC","Non Metro"]
[3926,3944,"VIC","Metro"]
[3945,3971,"VIC","Non Metro"]
[3972,3978,"VIC","Metro"]
[3979,3979,"VIC","Non Metro"]
[3980,3983,"VIC","Metro"]
[3984,3999,"VIC","Non Metro"]
[4000,4004,"QLD","Inner City"]
[4005,4209,"QLD","Metro"]
[4210,4299,"QLD","Non Metro"]
[4300,4306,"QLD","Metro"]
[4307,4499,"QLD","Non Metro"]
[4500,4549,"QLD","Metro"]
[4550,4999,"QLD","Non Metro"]
[5000,5005,"SA","Inner City"]
[5006,5199,"SA","Metro"]
[5200,5799,"SA","Non Metro"]
[5800,5999,"SA","Metro"]
[6000,6004,"WA","Inner City"]
[6005,6214,"WA","Metro"]
[6215,6799,"WA","Non Metro"]
[6800,6999,"WA","Metro"]
[7000,7003,"TAS","Inner City"]
[7004,7199,"TAS","Metro"]
[7200,7799,"TAS","Non Metro"]
[7800,7899,"TAS","Metro"]
[7900,7999,"TAS","Non Metro"]
[8000,8399,"VIC","Inner City"]
[8400,8899,"VIC","Metro"]
[8900,8999,"VIC","Non Metro"]
[9000,9299,"QLD","Inner City"]
[9300,9399,"QLD","Non Metro"]
[9400,9596,"QLD","Metro"]
[9597,9597,"QLD","Non Metro"]

{"sheet":"Calculations","index":5,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Applicants","Total","1","2","3","4","5","6",null,"Calculation Notes"]
[null,"PAYG Gross",{"$f":"IF(vApplicants<=0,0,SUM(OFFSET($D3,0,0,1,vApplicants)))","v":150000},{"$f":"OFFSET('Serviceability Calculator'!$C28,(D$2-1)*vApplicant_Rows,0)","v":150000},{"$f":"OFFSET('Serviceability Calculator'!$C28,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Self Employed Income",0,{"$f":"OFFSET('Serviceability Calculator'!$C34,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(I$2-1)*vApplicant_Rows,0)","v":0},null,"Self Employed Net Profit (Loss) Before Tax (NPBT)"]
[null,"Overtime / Allowance",0,{"$f":"OFFSET('Serviceability Calculator'!$C44,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Bonus / Commission",0,{"$f":"OFFSET('Serviceability Calculator'!$C46,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Investment",0,{"$f":"OFFSET('Serviceability Calculator'!$C48,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Other",0,{"$f":"OFFSET('Serviceability Calculator'!$C50,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Rental Income 1",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(I$2-1)*vApplicant_Rows,0),2)","v":0},null,"% Ownership applied to Rent Received"]
[null,"Rental Income 2",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 3",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 4",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 5",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 6",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 7",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 8",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 9",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 10",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Total Income",150000,{"$f":"SUM(D3:D18)","v":150000},0,0,0,0,0]
[null,"Rental Shading",0,{"$f":"SUM(D9:D18)*(1-vRentalShading)","v":0},0,0,0,0,0]
[null,"Gross Annual Income",150000,{"$f":"D19-D20","v":150000},{"$f":"E19-E20","v":0},0,0,0,0]
[null,"Interest Deductions 1",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},null,"Gearing Rate entered for the Investment Loan Amount, % Ownership also applied"]
[null,"Interest Deductions 2",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 3",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 4",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 5",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 6",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 7",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 8",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 9",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 10",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,{"$f":"\"Rental Deductions \"&IF(vPropertyExpense=0,\"(N/A)\",\"@ \"&TEXT(vPropertyExpense,\"0.00%\"))","v":"Rental Deductions (N/A)"},0,{"$f":"IF(vPropertyExpense=0,0,ROUND(SUM(D9:D18)/(1-vPropertyExpense)*vPropertyExpense,2))","v":0},{"$f":"IF(vPropertyExpense=0,0,ROUND(SUM(E9:E18)/(1-vPropertyExpense)*vPropertyExpense,2))","v":0},0,0,0,0]
[null,"Taxable Gross Income",150000,{"$f":"D21-SUM(D22:D32)","v":150000},{"$f":"E21-SUM(E22:E32)","v":0},0,0,0,0,null,"Taxable Gross Income used for HEM Calculation"]
[null,"Income Tax and Medicare",43567,{"$f":"IF(D33<=0,0,ROUND(VLOOKUP(D33,tIncomeTax,3)+(D33-VLOOKUP(D33,tIncomeTax,1))*VLOOKUP(D33,tIncomeTax,2)+D33*vMedicareLevy,2))","v":43567},0,0,0,0,0,null,"From PAYG Table plus Medicare Rate"]
[null,"Non-Taxable",0,{"$f":"OFFSET('Serviceability Calculator'!$C30,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Self Employed Add Backs",0,{"$f":"OFFSET('Serviceability Calculator'!$C36,(D$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(D$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(E$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(E$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(F$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(F$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(G$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(G$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(H$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(H$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(I$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(I$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(I$2-1)*vApplicant_Rows,0)","v":0},null,"Includes Interest, Other Addbacks and Depreciation"]
[null,"Net Annual Income",106433,{"$f":"D21-D34+D35+D36","v":106433},0,0,0,0,0]
[null,"Hem Expenses (Weekly)",0,{"$f":"ROUND(OFFSET(vHEM,D$2,0),0)","v":0},0,0,0,0,0]
[null,"HEM Expenses",0,{"$f":"ROUND(D38*52/12,0)","v":0},{"$f":"ROUND(E38*52/12,0)","v":0},0,0,0,0,null,"From the HEM Table"]
[]
[null,"Company","Total","1"]
[null,"Company Net Profit Before Tax",{"$f":"IF(vCompany,D42,0)","v":0},{"$f":"'Serviceability Calculator'!$C330","v":0}]
[null,"Rental Income 1",0,{"$f":"ROUND('Serviceability Calculator'!$C343*'Serviceability Calculator'!$D343,2)","v":0},null,null,null,null,null,null,"% Ownership applied to Rent Received"]
[null,"Rental Income 2",0,{"$f":"ROUND('Serviceability Calculator'!$C344*'Serviceability Calculator'!$D344,2)","v":0}]
[null,"Rental Income 3",0,{"$f":"ROUND('Serviceability Calculator'!$C345*'Serviceability Calculator'!$D345,2)","v":0}]
[null,"Rental Income 4",0,{"$f":"ROUND('Serviceability Calculator'!$C346*'Serviceability Calculator'!$D346,2)","v":0}]
[null,"Rental Income 5",0,{"$f":"ROUND('Serviceability Calculator'!$C347*'Serviceability Calculator'!$D347,2)","v":0}]
[null,"Rental Income 6",0,{"$f":"ROUND('Serviceability Calculator'!$C348*'Serviceability Calculator'!$D348,2)","v":0}]
[null,"Rental Income 7",0,{"$f":"ROUND('Serviceability Calculator'!$C349*'Serviceability Calculator'!$D349,2)","v":0}]
[null,"Rental Income 8",0,{"$f":"ROUND('Serviceability Calculator'!$C350*'Serviceability Calculator'!$D350,2)","v":0}]
[null,"Rental Income 9",0,{"$f":"ROUND('Serviceability Calculator'!$C351*'Serviceability Calculator'!$D351,2)","v":0}]
[null,"Rental Income 10",0,{"$f":"ROUND('Serviceability Calculator'!$C352*'Serviceability Calculator'!$D352,2)","v":0}]
[null,"Total Income",0,{"$f":"SUM(D42:D52)","v":0}]
[null,"Rental Shading",0,{"$f":"SUM(D43:D52)*(1-vRentalShading)","v":0}]
[null,"Gross Annual Income",0,{"$f":"D53-D54","v":0}]
[null,"Interest Deductions 1",0,{"$f":"ROUND('Serviceability Calculator'!$E343*'Serviceability Calculator'!$D343*vGearing,2)","v":0},null,null,null,null,null,null,"Gearing Rate entered for the Investment Loan Amount, % Ownership also applied"]
[null,"Interest Deductions 2",0,{"$f":"ROUND('Serviceability Calculator'!$E344*'Serviceability Calculator'!$D344*vGearing,2)","v":0}]
[null,"Interest Deductions 3",0,{"$f":"ROUND('Serviceability Calculator'!$E345*'Serviceability Calculator'!$D345*vGearing,2)","v":0}]
[null,"Interest Deductions 4",0,{"$f":"ROUND('Serviceability Calculator'!$E346*'Serviceability Calculator'!$D346*vGearing,2)","v":0}]
[null,"Interest Deductions 5",0,{"$f":"ROUND('Serviceability Calculator'!$E347*'Serviceability Calculator'!$D347*vGearing,2)","v":0}]
[null,"Interest Deductions 6",0,{"$f":"ROUND('Serviceability Calculator'!$E348*'Serviceability Calculator'!$D348*vGearing,2)","v":0}]
[null,"Interest Deductions 7",0,{"$f":"ROUND('Serviceability Calculator'!$E349*'Serviceability Calculator'!$D349*vGearing,2)","v":0}]
[null,"Interest Deductions 8",0,{"$f":"ROUND('Serviceability Calculator'!$E350*'Serviceability Calculator'!$D350*vGearing,2)","v":0}]
[null,"Interest Deductions 9",0,{"$f":"ROUND('Serviceability Calculator'!$E351*'Serviceability Calculator'!$D351*vGearing,2)","v":0}]
[null,"Interest Deductions 10",0,{"$f":"ROUND('Serviceability Calculator'!$E352*'Serviceability Calculator'!$D352*vGearing,2)","v":0}]
[null,"Taxable Gross Income",0,{"$f":"D55-SUM(D56:D65)","v":0}]
[null,{"$f":"\"Company Tax @ \"&TEXT(vCompanyTaxRate,\"0.00%\")","v":"Company Tax @ 25.00%"},0,{"$f":"IF(D66<=0,0,ROUND(D66*vCompanyTaxRate,2))","v":0},null,null,null,null,null,null,"Using Company Tax Rate entered"]
[null,"Company Addbacks",0,{"$f":"'Serviceability Calculator'!$C332+'Serviceability Calculator'!$C334+'Serviceability Calculator'!$C336","v":0},null,null,null,null,null,null,"Includes Interest, Other Addbacks and Depreciation"]
[null,"Company Profit After Tax",0,{"$f":"D55-D67+D68","v":0}]
[]
[null,"Commitments (Annual)","Used","Repayment","Limit",{"$f":"\"Assessed at \"&TEXT(vFloorRate,\"0.00%\")","v":"Assessed at 6.00%"}]
[null,"Commitment 1",{"$f":"IF(vResidential,MAX(D72,F72),MAX(D72,F72))","v":0},{"$f":"'Serviceability Calculator'!$D360*12","v":0},{"$f":"IF('Serviceability Calculator'!$E360=\"N/A\",0,'Serviceability Calculator'!E360)","v":0},{"$f":"IF(E72=0,0,-PMT(vFloorRate/12,vLoanTerm*12,E72)*12)","v":0},null,null,null,null,"Assessed using Floor Rate entered"]
[null,"Commitment 2",0,{"$f":"'Serviceability Calculator'!$D361*12","v":0},{"$f":"IF('Serviceability Calculator'!$E361=\"N/A\",0,'Serviceability Calculator'!E361)","v":0},0]
[null,"Commitment 3",0,{"$f":"'Serviceability Calculator'!$D362*12","v":0},{"$f":"IF('Serviceability Calculator'!$E362=\"N/A\",0,'Serviceability Calculator'!E362)","v":0},0]
[null,"Commitment 4",0,{"$f":"'Serviceability Calculator'!$D363*12","v":0},{"$f":"IF('Serviceability Calculator'!$E363=\"N/A\",0,'Serviceability Calculator'!E363)","v":0},0]
[null,"Commitment 5",0,{"$f":"'Serviceability Calculator'!$D364*12","v":0},{"$f":"IF('Serviceability Calculator'!$E364=\"N/A\",0,'Serviceability Calculator'!E364)","v":0},0]
[null,"Commitment 6",0,{"$f":"'Serviceability Calculator'!$D365*12","v":0},{"$f":"IF('Serviceability Calculator'!$E365=\"N/A\",0,'Serviceability Calculator'!E365)","v":0},0]
[null,"Commitment 7",0,{"$f":"'Serviceability Calculator'!$D366*12","v":0},{"$f":"IF('Serviceability Calculator'!$E366=\"N/A\",0,'Serviceability Calculator'!E366)","v":0},0]
[null,"Commitment 8",0,{"$f":"'Serviceability Calculator'!$D367*12","v":0},{"$f":"IF('Serviceability Calculator'!$E367=\"N/A\",0,'Serviceability Calculator'!E367)","v":0},0]
[null,"Commitment 9",0,{"$f":"'Serviceability Calculator'!$D368*12","v":0},{"$f":"IF('Serviceability Calculator'!$E368=\"N/A\",0,'Serviceability Calculator'!E368)","v":0},0]
[null,"Commitment 10",0,{"$f":"'Serviceability Calculator'!$D369*12","v":0},{"$f":"IF('Serviceability Calculator'!$E369=\"N/A\",0,'Serviceability Calculator'!E369)","v":0},0]
[null,"Total Repayments",{"$f":"SUM(C72:C81)","v":0},{"$f":"SUM(D72:D81)","v":0},{"$f":"SUM(E72:E81)","v":0},{"$f":"SUM(F72:F81)","v":0}]
[null,"Credit Cards",{"$f":"D83","v":0},{"$f":"'Serviceability Calculator'!$C371*vCCRate*12","v":0},{"$f":"'Serviceability Calculator'!C371","v":0},{"$f":"D83","v":0},null,null,null,null,"Credit Card Limits x Credit Card Rate entered"]
[null,"Total Commitments",{"$f":"SUM(C82:C83)","v":0},{"$f":"SUM(D82:D83)","v":0},{"$f":"SUM(E82:E83)","v":0},{"$f":"SUM(F82:F83)","v":0}]
[null,"Living Expenses",{"$f":"IF(OR(D85>F85),D85,F85)","v":0},{"$f":"'Serviceability Calculator'!$C373*12","v":0},null,{"$f":"vHEM_Amount*12","v":0},null,null,null,null,"Higher of Actual or HEM"]
[null,"Loan Applied For",{"$f":"F86","v":19113.762301329465},{"$f":"'Serviceability Calculator'!C393","v":14033.508121406219},{"$f":"vLoan_Amount","v":213213},{"$f":"'Serviceability Calculator'!E393","v":19113.762301329465}]
[null,"Total Limits",{"$f":"E87","v":213213},null,{"$f":"SUM(E84:E86)","v":213213}]

{"sheet":"HEM Calculator","index":6,"n_rows":11,"n_cols":24,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,2,1],[1,2,1,6],[1,12,1,21]]}
[]
[null,"Applicant","Entries",null,null,null,null,null,null,null,null,null,"HEM"]
[null,null,"Postcode","Applying As","Coupled With","Dependents","Gross+NonTax Inc","Poscode Chek","State - Location","Region Check","HEM CoupleID","Couple Income","Region","Household","Dependents","Gr + NonTax Inc","HEM Row","HEM Col","HEM Dep's > 3","Benchmark","Minimum","HEM Weekly"]
[null,1,{"$f":"OFFSET(vApplicant_Postcode,($B4-1)*ROWS(vForm_Applicant),0)","v":0},{"$f":"T(OFFSET(vApplicant_Marital,($B4-1)*ROWS(vForm_Applicant),0))","v":""},{"$f":"OFFSET(vApplicant_Joint,($B4-1)*ROWS(vForm_Applicant),0)","v":0},{"$f":"IF($C4=0,\"\",OFFSET(vApplicant_Dependents,($B4-1)*ROWS(vForm_Applicant),0))","v":""},{"$f":"IF($C4=0,\"\",OFFSET(vApplicants_TotalGrossIncome,0,$B4)+OFFSET(vApplicants_NonTaxableIncome,0,$B4))","v":""},{"$f":"IF($C4=0,\"\",IF(OR($C4<MIN(OFFSET(tPostcodes,0,0,,1)),$C4>MAX(OFFSET(tPostcodes,0,0,,1))),-1,MATCH($C4,OFFSET(tPostcodes,0,0,,1))))","v":""},{"$f":"IF($C4=0,\"\",IF($H4=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H4,3)&\" - \"&INDEX(tPostcodes,$H4,4)))","v":""},{"$f":"IF($C4=0,\"\",IF($H4=-1,-1,MATCH($I4,OFFSET(tRegion_HEM,0,2,ROWS(tRegion_HEM),1),0)))","v":""},0,{"$f":"IF($D4=\"Couple\",(MATCH($K4,K:K,0)=ROW($K4))*1,0)","v":0},{"$f":"IF(OR($C4=0,$H4=-1,ISERROR($H4)),\"\",OFFSET(tRegion_HEM,J4-1,3,1,1))","v":""},{"$f":"IF($D4=\"\",\"\",VLOOKUP(D4,tHousehold_HEM,2,FALSE))","v":""},{"$f":"IF($C4=0,\"\",IF(F4<=3,F4,\"3 and above\"))","v":""},{"$f":"IF($C4=\"\",\"\",IF(K4=0,G4,SUMIF(K$4:K$9,K4,G$4:G$9)*L4))","v":""},null,null,{"$f":"IF(OR(O4<=3,R4=\"\",R4=0,Q4=\"\",Q4=0),IF($C4=0,\"\",0),OFFSET(HEM!$A$1,Q4,R4-1))","v":""},{"$f":"IF(OR(R4=\"\",R4=0,Q4=\"\",Q4=0),0,OFFSET(HEM!$A$1,Q4-1,R4-1)+(F4-3)*S4)","v":0},{"$f":"IF(OR($P4=0,$R4=\"\",$R4=0,$Q4=\"\",$Q4=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q4-1,0),OFFSET(HEM!$1:$1,$Q4-1,0),\">10\"))","v":0},{"$f":"MAX(T4:U4)","v":0},null,"`"]
[null,2,0,"",0,"","",{"$f":"IF($C5=0,\"\",IF(OR($C5<MIN(OFFSET(tPostcodes,0,0,,1)),$C5>MAX(OFFSET(tPostcodes,0,0,,1))),-1,MATCH($C5,OFFSET(tPostcodes,0,0,,1))))","v":""},{"$f":"IF($C5=0,\"\",IF($H5=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H5,3)&\" - \"&INDEX(tPostcodes,$H5,4)))","v":""},"",0,{"$f":"IF($D5=\"Couple\",(MATCH($K5,K:K,0)=ROW($K5))*1,0)","v":0},"","",{"$f":"IF($C5=0,\"\",IF(F5<=3,F5,\"3 and above\"))","v":""},"",null,null,{"$f":"IF(OR(O5<=3,R5=\"\",R5=0,Q5=\"\",Q5=0),IF($C5=0,\"\",0),OFFSET(HEM!$A$1,Q5,R5-1))","v":""},{"$f":"IF(OR(R5=\"\",R5=0,Q5=\"\",Q5=0),0,OFFSET(HEM!$A$1,Q5-1,R5-1)+(F5-3)*S5)","v":0},{"$f":"IF(OR($P5=0,$R5=\"\",$R5=0,$Q5=\"\",$Q5=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q5-1,0),OFFSET(HEM!$1:$1,$Q5-1,0),\">10\"))","v":0},{"$f":"MAX(T5:U5)","v":0}]
[null,3,0,"",0,"","","",{"$f":"IF($C6=0,\"\",IF($H6=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H6,3)&\" - \"&INDEX(tPostcodes,$H6,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(O6<=3,R6=\"\",R6=0,Q6=\"\",Q6=0),IF($C6=0,\"\",0),OFFSET(HEM!$A$1,Q6,R6-1))","v":""},{"$f":"IF(OR(R6=\"\",R6=0,Q6=\"\",Q6=0),0,OFFSET(HEM!$A$1,Q6-1,R6-1)+(F6-3)*S6)","v":0},{"$f":"IF(OR($P6=0,$R6=\"\",$R6=0,$Q6=\"\",$Q6=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q6-1,0),OFFSET(HEM!$1:$1,$Q6-1,0),\">10\"))","v":0},0]
[null,4,0,"",0,"","","",{"$f":"IF($C7=0,\"\",IF($H7=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H7,3)&\" - \"&INDEX(tPostcodes,$H7,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(O7<=3,R7=\"\",R7=0,Q7=\"\",Q7=0),IF($C7=0,\"\",0),OFFSET(HEM!$A$1,Q7,R7-1))","v":""},{"$f":"IF(OR(R7=\"\",R7=0,Q7=\"\",Q7=0),0,OFFSET(HEM!$A$1,Q7-1,R7-1)+(F7-3)*S7)","v":0},{"$f":"IF(OR($P7=0,$R7=\"\",$R7=0,$Q7=\"\",$Q7=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q7-1,0),OFFSET(HEM!$1:$1,$Q7-1,0),\">10\"))","v":0},0]
[null,5,0,"",0,"","","",{"$f":"IF($C8=0,\"\",IF($H8=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H8,3)&\" - \"&INDEX(tPostcodes,$H8,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(O8<=3,R8=\"\",R8=0,Q8=\"\",Q8=0),IF($C8=0,\"\",0),OFFSET(HEM!$A$1,Q8,R8-1))","v":""},{"$f":"IF(OR(R8=\"\",R8=0,Q8=\"\",Q8=0),0,OFFSET(HEM!$A$1,Q8-1,R8-1)+(F8-3)*S8)","v":0},{"$f":"IF(OR($P8=0,$R8=\"\",$R8=0,$Q8=\"\",$Q8=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q8-1,0),OFFSET(HEM!$1:$1,$Q8-1,0),\">10\"))","v":0},0]
[null,6,0,"",0,"","","",{"$f":"IF($C9=0,\"\",IF($H9=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H9,3)&\" - \"&INDEX(tPostcodes,$H9,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(O9<=3,R9=\"\",R9=0,Q9=\"\",Q9=0),IF($C9=0,\"\",0),OFFSET(HEM!$A$1,Q9,R9-1))","v":""},{"$f":"IF(OR(R9=\"\",R9=0,Q9=\"\",Q9=0),0,OFFSET(HEM!$A$1,Q9-1,R9-1)+(F9-3)*S9)","v":0},{"$f":"IF(OR($P9=0,$R9=\"\",$R9=0,$Q9=\"\",$Q9=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q9-1,0),OFFSET(HEM!$1:$1,$Q9-1,0),\">10\"))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HEM_col(P10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HEM_col(P11)","v":""}]

{"sheet":"Drivers","index":7,"n_rows":102,"n_cols":60,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,52,0,59],[0,43,0,50],[11,1,11,2],[7,1,7,2],[0,34,0,41],[1,7,1,8],[1,4,1,5],[1,1,1,2],[1,23,1,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Printed Form Rows Hidden",null,null,null,null,null,null,null,null,"Printed Form Sections",null,null,null,null,null,null,null,null,"Printed Form Rows Print"]
[null,"Defaults",null,null,"Application",null,null,"Assessment",null,null,"Repayments",null,"I/O Period",null,"State","Location","State - Location","HEM Region",null,"Marital","HEM Houshold",null,null,"Joint with Applicant",null,null,null,null,null,null,"Commitments",null,"Frequency",null,"Row","Applicant 1","Applicant 2","Applicant 3","Applicant 4","Applicant 5","Applicant 6","Company",null,"Section","1","2","3","4","5","6","Company",null,"Row","1","2","3","4","5","6","Company"]
[null,null,null,null,null,null,null,null,null,null,"Principal and Interest",null,0,null,"NSW","Inner City","NSW - Inner City","Sydney",null,"Sole Borrower","Couple",null,"Applicant",1,2,3,4,5,6,null,"Other Mortgage",null,"Annually",null,1,30,null,null,null,null,null,null,null,0,{"$f":"AND(AS$2*1<=vApplicants,OR(COUNTIF(AS$4:AS$6,TRUE)>0,AS$7*1>0))","v":true},false,false,false,false,false,{"$f":"AND(vCompany,OR(COUNTIF(AY$4,TRUE)>0,AY$5*1>0))","v":false},null,1,{"$f":"IF(AS$3,1,0)","v":1},{"$f":"IF(AT$3,1,0)","v":0},0,0,0,0,{"$f":"IF(AY$3,1,0)","v":0}]
[null,"Applicants Max",6,null,"LVR",{"$f":"IF(OR(vLoan_Amount=0,vLoan_Security=0),0,ROUND(vLoan_Amount/vLoan_Security,4))","v":0.2132},null,"Total Income",{"$f":"Calculations!C19+Calculations!C35+Calculations!C36+Calculations!C53+Calculations!C68","v":150000},null,"Interest Only",null,1,null,"NSW","Metro","NSW - Metro","Sydney",null,"Single","Single",null,"Couple",{"$f":"(OFFSET(vApplicant_Marital,(X$3-1)*vApplicant_Rows,0)=\"\")","v":true},true,true,true,true,true,null,"Rental Expense",null,"Monthly",null,2,6,null,null,null,null,null,null,null,1,{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AS$2-1)*vApplicant_Rows,0)))>0","v":true},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AT$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AU$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AV$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AW$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AX$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS('Serviceability Calculator'!$C$330:$C$336))>0","v":false},null,2,{"$f":"IF(AS$3,1,0)","v":1},0,0,0,0,0,0]
[null,"Open","˅",null,"LVR Amount",{"$f":"IF(vLoan_Security=0,100000000,vLoan_Security)","v":1000000},null,null,null,null,null,null,2,null,"NSW","Non Metro","NSW - Non Metro","Balance of NSW",null,"Couple","Couple",null,"Couple",{"$f":"(OFFSET(vApplicant_Marital,(X$3-1)*vApplicant_Rows,0)=\"Couple\")","v":false},false,false,false,false,false,null,"Personal Loan",null,"Weekly",null,3,15,null,null,null,null,null,null,null,2,{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AS$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AT$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AU$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AV$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AW$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AX$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"vCompany_Properties","v":0},null,3,{"$f":"IF(AS$3,1,0)","v":1},0,0,0,0,0,0]
[null,"Close","˄",null,"LVR Security",{"$f":"IF(vLoan_Amount=0,100000000,vLoan_Amount)","v":213213},null,"Net Income",{"$f":"'Serviceability Calculator'!E$385","v":106433},null,null,null,3,null,"VIC","Inner City","VIC - Inner City","Melbourne",null,null,null,null,"Row",{"$f":"IF(X4,12,IF(X$5,7,6))","v":12},{"$f":"IF(Y4,12,IF(Y$5,7,6))","v":12},12,12,12,12,null,"Hire Purchase / Lease",null,"Fortnighly",null,4,8.5,null,null,null,null,null,null,null,3,{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AS$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AT$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AU$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AV$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AW$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AX$2-1)*vApplicant_Rows,0)))>0","v":false},null,null,4,1,0,0,0,0,0,0]
[null,null,null,null,"LVR Passed",{"$f":"(vLVR<=100%)","v":true},null,null,null,null,null,null,4,null,"VIC","Metro","VIC - Metro","Melbourne",null,null,null,null,"Rows",{"$f":"IF(X$5,IF(vLoan_Applicants=0,1,vLoan_Applicants-1),1)","v":1},1,1,1,1,1,null,"HECS / Education",null,null,null,5,15,null,null,null,null,null,null,null,4,{"$f":"SUM(OFFSET(vApplicant_Properties,(AS$2-1)*vApplicant_Rows,0))","v":0},0,0,0,0,0,null,null,5,1,0,0,0,0,0,0]
[null,"Defaults",null,null,null,null,null,"Living Costs",{"$f":"'Serviceability Calculator'!E$389","v":0},null,null,null,5,null,"VIC","Non Metro","VIC - Non Metro","Balance of VIC",null,null,null,null,"List Range",{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,X6,X3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,X6+X7-1,X3-1,1,1))","v":"Drivers!$X$15:$X$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,Y6,Y3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,Y6+Y7-1,Y3-1,1,1))","v":"Drivers!$Y$15:$Y$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,Z6,Z3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,Z6+Z7-1,Z3-1,1,1))","v":"Drivers!$Z$15:$Z$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,AA6,AA3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,AA6+AA7-1,AA3-1,1,1))","v":"Drivers!$AA$15:$AA$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,AB6,AB3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,AB6+AB7-1,AB3-1,1,1))","v":"Drivers!$AB$15:$AB$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,AC6,AC3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,AC6+AC7-1,AC3-1,1,1))","v":"Drivers!$AC$15:$AC$15"},null,"Child Maintenance",null,null,null,6,6,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,6,1,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$4),1,0)","v":0}]
[null,"OpenClose Form",1,null,"I/O",{"$f":"vLoan_Type=OFFSET(tRepayments,1,0,1,1)","v":false},null,null,null,null,null,null,null,null,"QLD","Inner City","QLD - Inner City","Brisbane",null,null,null,null,null,0,0,0,0,0,0,null,"Other Commitment",null,null,null,7,15,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,7,1,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$4),1,0)","v":0}]
[null,"OpenClose Open",false,null,null,null,null,"Commitments",{"$f":"'Serviceability Calculator'!E$387","v":0},null,null,null,null,null,"QLD","Metro","QLD - Metro","Brisbane",null,null,null,null,null,2,1,1,1,1,1,null,null,null,null,null,8,6,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,8,1,0,0,0,0,0,0]
[null,null,null,null,"Applicants",{"$f":"IF(vLoan_Applicants<1,0,vLoan_Applicants)","v":1},null,null,null,null,null,null,null,null,"QLD","Non Metro","QLD - Non Metro","Balance of QLD",null,null,null,null,null,3,3,2,2,2,2,null,null,null,null,null,9,20.25,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,9,1,0,0,0,0,0,0]
[null,"HEM",null,null,"Applicant Rows",{"$f":"ROWS(vForm_Applicant)","v":51},null,"Debt Assessed",{"$f":"'Serviceability Calculator'!E$387+'Serviceability Calculator'!E$389","v":0},null,null,null,null,null,"SA","Inner City","SA - Inner City","Adelaide",null,null,null,null,null,4,4,4,3,3,3,null,null,null,null,null,10,6,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,10,{"$f":"IF(AND(AS$3,AS$4),1,0)","v":1},{"$f":"IF(AND(AT$3,AT$4),1,0)","v":0},0,0,0,0,0]
[null,null,null,null,"Applicant Joints",{"$f":"IF(vApplicants-1<=0,1,vApplicants-1)","v":1},null,null,null,null,null,null,null,null,"SA","Metro","SA - Metro","Adelaide",null,null,null,null,null,5,5,5,5,4,4,null,null,null,null,null,11,15,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,11,{"$f":"IF(AND(AS$3,AS$4),1,0)","v":1},0,0,0,0,0,0]
[null,"Income Max",{"$f":"MAX(HEM!$2:$2)","v":357000},null,null,null,null,"Debt Serviced",{"$f":"'Serviceability Calculator'!E$387+'Serviceability Calculator'!E$393","v":19113.762301329465},null,null,null,null,null,"SA","Non Metro","SA - Non Metro","Balance of SA",null,null,null,null,null,6,6,6,6,6,5,null,null,null,null,null,12,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,1,0,0,0,0,0,0]
[null,"CoupleID",{"$f":"MATCH(\"HEM \"&B15,OFFSET(tApplicant_HEM,-1,0,1),0)","v":10},null,"Company",{"$f":"(vLoan_Company=\"Yes\")","v":false},null,null,null,null,null,null,null,null,"WA","Inner City","WA - Inner City","Perth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1,0,0,0,0,0,0]
[null,"Row",{"$f":"MATCH(\"HEM \"&B16,OFFSET(tApplicant_HEM,-1,0,1),0)","v":16},null,null,null,null,"Repayments",{"$f":"IF(vLoan_Term=0,0,-PMT((vLoan_Rate+vBuffer)/12,(vLoan_Term-IF(bIO,vLoan_IOPeriod*12,0)),vLoan_Amount)*12)","v":19113.762301329465},null,null,null,null,null,"WA","Metro","WA - Metro","Perth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(AS$3,1,0)","v":1},{"$f":"IF(AT$3,1,0)","v":0},{"$f":"IF(AU$3,1,0)","v":0},{"$f":"IF(AV$3,1,0)","v":0},{"$f":"IF(AW$3,1,0)","v":0},{"$f":"IF(AX$3,1,0)","v":0},{"$f":"IF(AY$3,1,0)","v":0}]
[null,"Col",{"$f":"MATCH(\"HEM \"&B17,OFFSET(tApplicant_HEM,-1,0,1),0)","v":17},null,"Regulated",{"$f":"(vLoan_Regulated<>\"No\")","v":true},null,null,null,null,null,null,null,null,"WA","Non Metro","WA - Non Metro","Balance of WA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,20.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,1,0,0,0,0,0,0]
[null,null,null,null,"Refinance",{"$f":"(vLoan_Purpose=\"Refinance\")","v":false},null,"Avaliable Income",{"$f":"'Serviceability Calculator'!E$391","v":106433},null,null,null,null,null,"TAS","Inner City","TAS - Inner City","Hobart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(AND(AS$3,AS$5),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$5),1,0)","v":0},0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=1),1,0)","v":0}]
[null,null,null,null,"Residential",{"$f":"vRegulated","v":true},null,null,null,null,null,null,null,null,"TAS","Metro","TAS - Metro","Hobart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(AND(AS$3,AS$5),1,0)","v":0},0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=1),1,0)","v":0}]
[null,null,null,null,"Buffer",{"$f":"IF(vResidential,IF(vRefinance,vBuffer_Refinance_Residential,vBuffer_Residential),IF(vRefinance,vBuffer_Refinance_Commercial,vBuffer_Commercial))","v":0.03},null,"NDI Ratio",{"$f":"ROUND(IF(vAssessed_Commitments+vAssessed_Repayments=0,1,(vAssessed_Net_Income-vAssessed_LivingCosts)/(vAssessed_Commitments+vAssessed_Repayments)),2)","v":5.57},null,null,null,null,null,"TAS","Non Metro","TAS - Non Metro","Balance of TAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,0,0,0]
[null,null,null,null,"Floor Rate",{"$f":"IF(vResidential,vFloorRate_Residential,vFloorRate_Commercial)","v":0.06},null,null,null,null,null,null,null,null,"ACT","Metro","ACT - Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,0,0,0]
[null,null,null,null,"Interest Gearing",{"$f":"IF(vResidential,vGearing_Residential,vGearing_Commercial)","v":3.7499999999999999E-2},null,"NDI Factor",{"$f":"TEXT(vAssessed_NDI_Ratio,\"0.00\")&\" : 1\"","v":"5.57 : 1"},null,null,null,null,null,"ACT","Non Metro","ACT - Non Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,0,0,0]
[null,null,null,null,"Credit Card",{"$f":"IF(vResidential,vCCRate_Residential,vCCRate_Commercial)","v":3.7999999999999999E-2},null,null,null,null,null,null,null,null,"NT","Metro","NT - Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=2),1,0)","v":0}]
[null,null,null,null,"Loan Term",{"$f":"IF(vResidential,vLoanTerm_Residential,vLoanTerm_Commercial)","v":30},null,"DSC Factor",{"$f":"TEXT(IF(OR(vAssessed_Net_Income=0,vServiced_Debt=0),1.25,vAssessed_Net_Income/vServiced_Debt),\"0.00\")&\" : 1\"","v":"5.57 : 1"},null,null,null,null,null,"NT","Non Metro","NT - Non Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=3),1,0)","v":0}]
[null,null,null,null,"Rental Shading",{"$f":"IF(vResidential,vRentalShading_Residential,vRentalShading_Commercial)","v":0.8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=4),1,0)","v":0}]
[null,null,null,null,"Prperty Expense",{"$f":"IF(vResidential,vPropertyExpense_Residential,vPropertyExpense_Commercial)","v":0},null,"Factor",{"$f":"IF(vAssessed_NDI_Ratio<1,3,IF(vAssessed_Available_Income<vAssessed_Repayments,2,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(AS$3,1,0)","v":1},{"$f":"IF(AT$3,1,0)","v":0},{"$f":"IF(AU$3,1,0)","v":0},{"$f":"IF(AV$3,1,0)","v":0},{"$f":"IF(AW$3,1,0)","v":0},{"$f":"IF(AX$3,1,0)","v":0},{"$f":"IF(AND(AY$3,AY$5*1>=5),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,20.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,1,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=6),1,0)","v":0}]
[null,null,null,null,"Repayments",{"$f":"IF(vLoan_Term=0,0,IF(bIO,vLoan_Amount*vLoan_Rate,-PMT(vLoan_Rate/12,vLoan_Term,vLoan_Amount)*12))","v":14033.508121406219},null,"Debt Actual",{"$f":"'Serviceability Calculator'!C$387+'Serviceability Calculator'!C$389","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(AND(AS$3,AS$6),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$6),1,0)","v":0},0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=7),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(AND(AS$3,AS$6),1,0)","v":0},0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=8),1,0)","v":0}]
[null,null,null,null,null,null,null,"Commitment Limit",{"$f":"Calculations!C87","v":213213},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=9),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=10),1,0)","v":0}]
[null,null,null,null,null,null,null,"DTI Factor",{"$f":"TEXT(IF(OR(vAssessed_Commitment_Limit=0,vAssessed_Income=0),1,vAssessed_Commitment_Limit/vAssessed_Income),\"0.0\")","v":"1.4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,0,0,0,0,0,{"$f":"IF(AY$3,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(AS$3,1,0)","v":1},{"$f":"IF(AT$3,1,0)","v":0},{"$f":"IF(AU$3,1,0)","v":0},{"$f":"IF(AV$3,1,0)","v":0},{"$f":"IF(AW$3,1,0)","v":0},{"$f":"IF(AX$3,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,20.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,1,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(AND(AS$3,AS$7*1>=1),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=1),1,0)","v":0},0,{"$f":"IF(AND(AV$3,AV$7*1>=1),1,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(AND(AS$3,AS$7*1>=1),1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF(AND(AS$3,AS$7*1>=2),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=2),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF(AND(AS$3,AS$7*1>=3),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=3),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(AND(AS$3,AS$7*1>=4),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=4),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(AND(AS$3,AS$7*1>=5),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=5),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(AND(AS$3,AS$7*1>=6),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=6),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(AND(AS$3,AS$7*1>=7),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=7),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(AND(AS$3,AS$7*1>=8),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=8),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(AND(AS$3,AS$7*1>=9),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=9),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(AND(AS$3,AS$7*1>=10),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=10),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(AS$3,1,0)","v":1},{"$f":"IF(AT$3,1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,{"$f":"IF(AS$3,1,0)","v":1},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]

{"sheet":"Scope Inputs","index":8,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[null,"https://caps.helia.com.au/serviceability-calculator/",null,null,null,null,null,null,"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"]
[null,null,null,null,null,null,null,null,null,"YBR Calculator"]
[null,null,null,null,null,null,null,null,null,"Macquarie Calculator"]
[null,"APPLICATION NAME (not Applicant Name)"]
[]
[]
[null,"PER APPLICANT"]
[]
[null,"PAYG"]
[]
[null,"Income Type",null,"Gross Only"]
[]
[null,"Include Variable Income, including Add more"]
[]
[null,"SELF EMPLOYED"]
[]
[null,"As is"]
[]
[null,"RENTAL INCOME"]
[]
[null,"Amount","Frequency","Ownership","Investment Loan"]
[]
[null,"Rental Type no required"]
[]
[]
[null,"NON Taxable"]
[]
[null,"As is"]
[]
[]
[]
[]
[null,"COMPANY"]
[]
[null,"Income",null,"As is"]
[]
[null,"Rental Income",null,"As is","(remove Rental Type)"]
[]
[]
[]
[]
[]
[]
[null,"COMMITMENTS",null,"Total for all Applicants"]
[]
[null,"As is"]

{"sheet":"Scope Results","index":9,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[null,"As per Gen Worth"]
[]
[null,"Then can Download detailed PDF"]

{"sheet":"Scope General","index":10,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Be able to brand as their own"]
[null,null,"Import Logo"]
[null,null,"Color Scheme"]
[]
[null,"Version Controlled"]
[]
[]
[null,"Date of Calculation included"]
[]
[]
[]
[null,"Input Tax Tables (Company and PAYG)"]
[]
[null,"Input HEM Tables (living costs)"]
[]
[null,"Commitments (to be decided)"]
[null,null,"For now, use actual, but ability to change"]
[null,null,"Buffer and Stress rates zero for now"]
[]
[null,null,"30 years with Benchmark Rate of 5.25%"]
[]
[]
[null,"Outputs"]
[null,null,"NDI Ratio","1 minimum",null,"Outgoings/Income"]
[null,null,"DTI ratio","need to know it"]